Tabela LPersonnelPerfService

Definicja tabeli LPersonnelPerfService

Name

LPersonnelPerfService

Code

LPersonnelPerfService

Comment

PL: Przyporzadkowanie uslug wykonywanych przez personel
EN: Assignemet services that may be performed by personel person


Lista kolumn tabeli LPersonnelPerfService

Name

Code

LPersonnelPerfServiceID

LPersonnelPerfServiceID

PersonnelFunctionID

PersonnelFunctionID

UserTypeID

UserTypeID

PersonID

PersonID

PerfServiceID

PerfServiceID

Main

Main

PersonnelFunction

PersonnelFunction

Comments

Comments


Kolumna LPersonnelPerfServiceID tabeli LPersonnelPerfService

Definicja kolumny LPersonnelPerfServiceID tabeli LPersonnelPerfService

Name

LPersonnelPerfServiceID

Code

LPersonnelPerfServiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonnelFunctionID tabeli LPersonnelPerfService

Definicja kolumny PersonnelFunctionID tabeli LPersonnelPerfService

Name

PersonnelFunctionID

Code

PersonnelFunctionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UserTypeID tabeli LPersonnelPerfService

Definicja kolumny UserTypeID tabeli LPersonnelPerfService

Name

UserTypeID

Code

UserTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli LPersonnelPerfService

Definicja kolumny PersonID tabeli LPersonnelPerfService

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PerfServiceID tabeli LPersonnelPerfService

Definicja kolumny PerfServiceID tabeli LPersonnelPerfService

Name

PerfServiceID

Code

PerfServiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Main tabeli LPersonnelPerfService

Definicja kolumny Main tabeli LPersonnelPerfService

Name

Main

Code

Main

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna PersonnelFunction tabeli LPersonnelPerfService

Definicja kolumny PersonnelFunction tabeli LPersonnelPerfService

Name

PersonnelFunction

Code

PersonnelFunction

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Comments tabeli LPersonnelPerfService

Definicja kolumny Comments tabeli LPersonnelPerfService

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Lista kluczy tabeli LPersonnelPerfService

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LPersonnelPerfService

Definicja klucza Identifier_1 tabeli LPersonnelPerfService

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment